package com.noahplat.datapro.mapper;

import com.noahplat.datapro.pojo.Sp;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

/**
 * @InterfaceName: SpProMapper
 * @Description: 设备剩余电量mapper
 * @Author 李景星
 * @Date 2021/3/4
 * @Version 1.0
 */
public interface SpProMapper extends Mapper<Sp> {

    /**
     * 查询设备剩余电量
     * @param imei
     * @return
     */
    @Select("select ts as ts, sp as sp from sp where imei=#{imei}")
    public Sp getNowSp(@Param("imei") String imei);
}
